DELETE FROM [Smart].[dbo].[MealLog]
GO

INSERT INTO [Smart].[dbo].[MealLog]
           ([CreatedBy]
           ,[CreatedOn]
           ,[MealId]
           ,[Quantity]
           ,[Energy]
           ,[Proteins]
           ,[Carbs]
           ,[Fats])
     VALUES
           (1,'1.6.2012 18:00', 1, 200, 100, 150, 20, 30),
           (1,'2.6.2012 18:00', 5, 150, 10, 10, 20, 5),
           (1,'2.6.2012 18:00', 21, 80, 100, 150, 20, 30),
           (1,'1.6.2012 18:00', 13, 300, 100, 150, 20, 30),
           (1,'1.6.2012 18:00', 31, 20, 100, 150, 20, 30),
           (2,'2.6.2012 18:00', 5, 150, 10, 10, 20, 5),
           (2,'2.6.2012 18:00', 21, 80, 100, 150, 20, 30),
           (2,'1.6.2012 18:00', 13, 300, 100, 150, 20, 30),
           (2,'1.6.2012 18:00', 31, 20, 100, 150, 20, 30),
           (3,'2.6.2012 18:00', 5, 150, 10, 10, 20, 5),
           (3,'2.6.2012 18:00', 21, 80, 100, 150, 20, 30),
           (3,'1.6.2012 18:00', 13, 300, 100, 150, 20, 30),
           (3,'1.6.2012 18:00', 31, 20, 100, 150, 20, 30),
           (4,'2.6.2012 18:00', 5, 150, 10, 10, 20, 5),
           (4,'2.6.2012 18:00', 21, 80, 100, 150, 20, 30),
           (4,'1.6.2012 18:00', 13, 300, 100, 150, 20, 30),
           (4,'1.6.2012 18:00', 31, 20, 100, 150, 20, 30)
GO


